# -*- coding: utf-8 -*-
import sys
sys.path.append("../..")
from db.mysql import MysqlClient
from common.helper import Helper
class Arrangement( object ):
    def __init__(self):
        self.mysql = MysqlClient()
        self.name = "女性关爱特定疾病险"
    def pullData(self, data={}):
        for item in Helper.selectData(self.name, self.mysql):
            data["name"] = self.name
            data["company"] = "中华保险"
            data["year"] = item["year"]
            data["gender"] = "0"
            data["expire"] = "1年"
            data["payType"] = "年交"
            data["breastCancer"] = str(int(int(item["breastCancer"])/10000)) + "w"
            data["womenSpeDisease"] = "2.5w" if item["womenSpeDisease"] == "25000" else "5w"
            data["womenGenCancer"] = "0.5w" if item["womenGenCancer"] == "5000" else "1w"
            data["womenSpeOperation"] = "1w"
            data["womenSpeTidy"] = "1w"
            data["price"] = item["price"]
            Helper.mergeTable("serious",self.mysql,data )
